package com.haina.shop.mapper;

import com.haina.shop.domain.Sku;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 48077
* @description 针对表【tz_sku(单品SKU表)】的数据库操作Mapper
* @createDate 2024-07-31 18:34:30
* @Entity com.haina.shop.domain.Sku
*/
public interface SkuMapper extends BaseMapper<Sku> {
@Select("select  * from tz_sku where prod_id=#{prodId}")
List<Sku> selectByProdId(Long prodId);
    @Select("select sku_name from yami_shops.tz_sku where sku_id=#{skuId}")
    String selectNameById(Long skuId);
    @Select("select * from yami_shops.tz_sku where sku_id=#{skuId}")
    String getDataById(Long skuId);
}




